select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (a.houseArea >= 100 and a.houseArea <= 200) and (b.cnpropertyname like '%Old house in Fumin Road%' or b.enpropertyname like '%Old house in Fumin Road%') order by updateTime Desc, a.dftpic desc
Fumin rd near Changle rd, nice decoration, fully furnished, open kitchen, good light, two bedrooms+two bathrooms, about 5mins walking to Line1 Changshu rd satio...
The community is a modern concise style,delicate decoration,European floor,water purification system,embedded oven,imported platen washing machine,constant temp...
2nd floor, 3rd floor and fouth floor, one bedroom with south direction and one small room, the master bedroom with large round balcony, bathroom with bath tub
Delicated decoration,the property comprises a brigh and sunny living room and well equipped contemporary kitchen, north-south transparent, good ventilation, goo...